﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsPagamentos" targetNamespace="http://tempuri.org/dsPagamentos.xsd" xmlns:mstns="http://tempuri.org/dsPagamentos.xsd" xmlns="http://tempuri.org/dsPagamentos.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SamecaGestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SamecaGestConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SamecaGestV2.My.MySettings.GlobalReference.Default.SamecaGestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FacturasPendentesTableAdapter" GeneratorDataComponentClassName="FacturasPendentesTableAdapter" Name="FacturasPendentes" UserDataComponentName="FacturasPendentesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        tblVendorLedgerEntry.[Document No_], tblVendorLedgerEntry.[External Document No_], tblVendorLedgerEntry.[Vendor No_], 
                         tblVendorLedgerEntry.[Amount (LCY) stats_] / - 1 AS Valor, tblVendorLedgerEntry.[Open], tblVendorLedgerEntry.[No_ Series], tblVendor.[Search Name], 
                         tblVendorLedgerEntry.[Document Date], tblFacturasEntregues.[Data Entrega], tblFacturasEntregues.Pessoa, tblFacturasEntregues.[No Factura], 
                         CASE WHEN tblFacturasEntregues.[No Factura] = tblVendorLedgerEntry.[Document No_] THEN 1 ELSE 0 END AS Entregue
FROM            tblVendorLedgerEntry INNER JOIN
                         tblVendor ON tblVendorLedgerEntry.[Vendor No_] = tblVendor.No_ FULL OUTER JOIN
                         tblFacturasEntregues ON tblVendorLedgerEntry.[Document No_] = tblFacturasEntregues.[No Factura] AND 
                         tblVendorLedgerEntry.Company = tblFacturasEntregues.Company
WHERE        (CASE WHEN tblFacturasEntregues.[No Factura] = tblVendorLedgerEntry.[Document No_] THEN 1 ELSE 0 END = 0) AND 
                         (tblVendorLedgerEntry.[Vendor No_] &lt;&gt; '9999') AND (tblVendorLedgerEntry.[Open] = 1) AND (tblVendorLedgerEntry.[No_ Series] LIKE 'c-%') AND 
                         (tblVendorLedgerEntry.[Vendor No_] &lt;&gt; '9998') AND (tblVendorLedgerEntry.[Vendor No_] &lt;&gt; '9997') AND (tblVendorLedgerEntry.[Vendor No_] &lt;&gt; '9996') AND 
                         (tblVendorLedgerEntry.[Vendor No_] &lt;&gt; '9995')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Document No_" DataSetColumn="Document No_" />
              <Mapping SourceColumn="External Document No_" DataSetColumn="External Document No_" />
              <Mapping SourceColumn="Vendor No_" DataSetColumn="Vendor No_" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="Open" DataSetColumn="Open" />
              <Mapping SourceColumn="No_ Series" DataSetColumn="No_ Series" />
              <Mapping SourceColumn="Search Name" DataSetColumn="Search Name" />
              <Mapping SourceColumn="Document Date" DataSetColumn="Document Date" />
              <Mapping SourceColumn="Data Entrega" DataSetColumn="Data Entrega" />
              <Mapping SourceColumn="Pessoa" DataSetColumn="Pessoa" />
              <Mapping SourceColumn="No Factura" DataSetColumn="No Factura" />
              <Mapping SourceColumn="Entregue" DataSetColumn="Entregue" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PessoasTableAdapter" GeneratorDataComponentClassName="PessoasTableAdapter" Name="Pessoas" UserDataComponentName="PessoasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        dbo.tblUsers.PrimeiroNome, dbo.tblUsers.UltimoNome, dbo.tblUserEMpresa.empresa, dbo.tblUsers.UserName
FROM            dbo.tblUsers INNER JOIN
                         dbo.tblUserEMpresa ON dbo.tblUsers.UserName = dbo.tblUserEMpresa.username
WHERE        (dbo.tblUserEMpresa.empresa = @empresa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="empresa" ColumnName="empresa" DataSourceName="" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="empresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PrimeiroNome" DataSetColumn="PrimeiroNome" />
              <Mapping SourceColumn="UltimoNome" DataSetColumn="UltimoNome" />
              <Mapping SourceColumn="empresa" DataSetColumn="empresa" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblFacturasEntreguesTableAdapter" GeneratorDataComponentClassName="tblFacturasEntreguesTableAdapter" Name="tblFacturasEntregues" UserDataComponentName="tblFacturasEntreguesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SamecaGest.dbo.tblFacturasEntregues" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblFacturasEntregues] WHERE (([No Factura] = @Original_No_Factura) AND ((@IsNull_Pessoa = 1 AND [Pessoa] IS NULL) OR ([Pessoa] = @Original_Pessoa)) AND ((@IsNull_Data_Entrega = 1 AND [Data Entrega] IS NULL) OR ([Data Entrega] = @Original_Data_Entrega)) AND ([Company] = @Original_Company))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_No_Factura" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="No Factura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pessoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Pessoa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_Entrega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data_Entrega" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblFacturasEntregues] ([No Factura], [Pessoa], [Data Entrega], [Company]) VALUES (@No_Factura, @Pessoa, @Data_Entrega, @Company);
SELECT [No Factura], Pessoa, [Data Entrega], Company FROM tblFacturasEntregues WHERE (Company = @Company) AND ([No Factura] = @No_Factura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@No_Factura" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="No Factura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Pessoa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data_Entrega" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        [No Factura], Pessoa, [Data Entrega], Company
FROM            tblFacturasEntregues</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblFacturasEntregues] SET [No Factura] = @No_Factura, [Pessoa] = @Pessoa, [Data Entrega] = @Data_Entrega, [Company] = @Company WHERE (([No Factura] = @Original_No_Factura) AND ((@IsNull_Pessoa = 1 AND [Pessoa] IS NULL) OR ([Pessoa] = @Original_Pessoa)) AND ((@IsNull_Data_Entrega = 1 AND [Data Entrega] IS NULL) OR ([Data Entrega] = @Original_Data_Entrega)) AND ([Company] = @Original_Company));
SELECT [No Factura], Pessoa, [Data Entrega], Company FROM tblFacturasEntregues WHERE (Company = @Company) AND ([No Factura] = @No_Factura)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@No_Factura" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="No Factura" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Pessoa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data_Entrega" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_No_Factura" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="No Factura" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pessoa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Pessoa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Pessoa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data_Entrega" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data_Entrega" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Data Entrega" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="No Factura" DataSetColumn="No Factura" />
              <Mapping SourceColumn="Pessoa" DataSetColumn="Pessoa" />
              <Mapping SourceColumn="Data Entrega" DataSetColumn="Data Entrega" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsPagamentos" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsPagamentos" msprop:Generator_UserDSName="dsPagamentos">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="FacturasPendentes" msprop:Generator_TableClassName="FacturasPendentesDataTable" msprop:Generator_TableVarName="tableFacturasPendentes" msprop:Generator_TablePropName="FacturasPendentes" msprop:Generator_RowDeletingName="FacturasPendentesRowDeleting" msprop:Generator_RowChangingName="FacturasPendentesRowChanging" msprop:Generator_RowEvHandlerName="FacturasPendentesRowChangeEventHandler" msprop:Generator_RowDeletedName="FacturasPendentesRowDeleted" msprop:Generator_UserTableName="FacturasPendentes" msprop:Generator_RowChangedName="FacturasPendentesRowChanged" msprop:Generator_RowEvArgName="FacturasPendentesRowChangeEvent" msprop:Generator_RowClassName="FacturasPendentesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Document_x0020_No_" msprop:Generator_ColumnVarNameInTable="columnDocument_No_" msprop:Generator_ColumnPropNameInRow="Document_No_" msprop:Generator_ColumnPropNameInTable="Document_No_Column" msprop:Generator_UserColumnName="Document No_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="External_x0020_Document_x0020_No_" msprop:Generator_ColumnVarNameInTable="columnExternal_Document_No_" msprop:Generator_ColumnPropNameInRow="External_Document_No_" msprop:Generator_ColumnPropNameInTable="External_Document_No_Column" msprop:Generator_UserColumnName="External Document No_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Vendor_x0020_No_" msprop:Generator_ColumnVarNameInTable="columnVendor_No_" msprop:Generator_ColumnPropNameInRow="Vendor_No_" msprop:Generator_ColumnPropNameInTable="Vendor_No_Column" msprop:Generator_UserColumnName="Vendor No_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnPropNameInTable="ValorColumn" msprop:Generator_UserColumnName="Valor" type="xs:decimal" minOccurs="0" />
              <xs:element name="Open" msprop:Generator_ColumnVarNameInTable="columnOpen" msprop:Generator_ColumnPropNameInRow="Open" msprop:Generator_ColumnPropNameInTable="OpenColumn" msprop:Generator_UserColumnName="Open" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="No__x0020_Series" msprop:Generator_ColumnVarNameInTable="columnNo__Series" msprop:Generator_ColumnPropNameInRow="No__Series" msprop:Generator_ColumnPropNameInTable="No__SeriesColumn" msprop:Generator_UserColumnName="No_ Series" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Search_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnSearch_Name" msprop:Generator_ColumnPropNameInRow="Search_Name" msprop:Generator_ColumnPropNameInTable="Search_NameColumn" msprop:Generator_UserColumnName="Search Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Document_x0020_Date" msprop:Generator_ColumnVarNameInTable="columnDocument_Date" msprop:Generator_ColumnPropNameInRow="Document_Date" msprop:Generator_ColumnPropNameInTable="Document_DateColumn" msprop:Generator_UserColumnName="Document Date" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Data_x0020_Entrega" msprop:Generator_ColumnVarNameInTable="columnData_Entrega" msprop:Generator_ColumnPropNameInRow="Data_Entrega" msprop:Generator_ColumnPropNameInTable="Data_EntregaColumn" msprop:Generator_UserColumnName="Data Entrega" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Pessoa" msprop:Generator_ColumnVarNameInTable="columnPessoa" msprop:Generator_ColumnPropNameInRow="Pessoa" msprop:Generator_ColumnPropNameInTable="PessoaColumn" msprop:Generator_UserColumnName="Pessoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="No_x0020_Factura" msprop:Generator_ColumnVarNameInTable="columnNo_Factura" msprop:Generator_ColumnPropNameInRow="No_Factura" msprop:Generator_ColumnPropNameInTable="No_FacturaColumn" msprop:Generator_UserColumnName="No Factura" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Entregue" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnEntregue" msprop:Generator_ColumnPropNameInRow="Entregue" msprop:Generator_ColumnPropNameInTable="EntregueColumn" msprop:Generator_UserColumnName="Entregue" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pessoas" msprop:Generator_TableClassName="PessoasDataTable" msprop:Generator_TableVarName="tablePessoas" msprop:Generator_TablePropName="Pessoas" msprop:Generator_RowDeletingName="PessoasRowDeleting" msprop:Generator_RowChangingName="PessoasRowChanging" msprop:Generator_RowEvHandlerName="PessoasRowChangeEventHandler" msprop:Generator_RowDeletedName="PessoasRowDeleted" msprop:Generator_UserTableName="Pessoas" msprop:Generator_RowChangedName="PessoasRowChanged" msprop:Generator_RowEvArgName="PessoasRowChangeEvent" msprop:Generator_RowClassName="PessoasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PrimeiroNome" msprop:Generator_ColumnVarNameInTable="columnPrimeiroNome" msprop:Generator_ColumnPropNameInRow="PrimeiroNome" msprop:Generator_ColumnPropNameInTable="PrimeiroNomeColumn" msprop:Generator_UserColumnName="PrimeiroNome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UltimoNome" msprop:Generator_ColumnVarNameInTable="columnUltimoNome" msprop:Generator_ColumnPropNameInRow="UltimoNome" msprop:Generator_ColumnPropNameInTable="UltimoNomeColumn" msprop:Generator_UserColumnName="UltimoNome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="empresa" msprop:Generator_ColumnVarNameInTable="columnempresa" msprop:Generator_ColumnPropNameInRow="empresa" msprop:Generator_ColumnPropNameInTable="empresaColumn" msprop:Generator_UserColumnName="empresa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblFacturasEntregues" msprop:Generator_TableClassName="tblFacturasEntreguesDataTable" msprop:Generator_TableVarName="tabletblFacturasEntregues" msprop:Generator_TablePropName="tblFacturasEntregues" msprop:Generator_RowDeletingName="tblFacturasEntreguesRowDeleting" msprop:Generator_RowChangingName="tblFacturasEntreguesRowChanging" msprop:Generator_RowEvHandlerName="tblFacturasEntreguesRowChangeEventHandler" msprop:Generator_RowDeletedName="tblFacturasEntreguesRowDeleted" msprop:Generator_UserTableName="tblFacturasEntregues" msprop:Generator_RowChangedName="tblFacturasEntreguesRowChanged" msprop:Generator_RowEvArgName="tblFacturasEntreguesRowChangeEvent" msprop:Generator_RowClassName="tblFacturasEntreguesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="No_x0020_Factura" msprop:Generator_ColumnVarNameInTable="columnNo_Factura" msprop:Generator_ColumnPropNameInRow="No_Factura" msprop:Generator_ColumnPropNameInTable="No_FacturaColumn" msprop:Generator_UserColumnName="No Factura">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pessoa" msprop:Generator_ColumnVarNameInTable="columnPessoa" msprop:Generator_ColumnPropNameInRow="Pessoa" msprop:Generator_ColumnPropNameInTable="PessoaColumn" msprop:Generator_UserColumnName="Pessoa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Data_x0020_Entrega" msprop:Generator_ColumnVarNameInTable="columnData_Entrega" msprop:Generator_ColumnPropNameInRow="Data_Entrega" msprop:Generator_ColumnPropNameInTable="Data_EntregaColumn" msprop:Generator_UserColumnName="Data Entrega" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn" msprop:Generator_UserColumnName="Company">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblFacturasEntregues" />
      <xs:field xpath="mstns:No_x0020_Factura" />
      <xs:field xpath="mstns:Company" />
    </xs:unique>
  </xs:element>
</xs:schema>